Quản lý nhân sự công ty bằng c# _ full source code
60.443 lượt xem;
- frmchonbcluong.cs
- QuanLyNhanSu /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using Telerik.Data;
13 using QuanLyNhanSu.Class;
14 namespace QuanLyNhanSu
15 {
16 public partial class frmchonbcluong : RadForm
17 {
18 //khai báo biến toàn cục
19 public SqlConnection sc = frmMain.me.sql.connectSQL();
20 public SqlDataAdapter sda = new SqlDataAdapter();
21 public DataSet ds = new DataSet();
22 clsdmpb cphong = new clsdmpb();
23 clsDMTo cto = new clsDMTo();
24 static public string thangbc = "";
25 static public string nambc = "";
26 static public string thangbh = "";
27 static public string nambh = "";
28 static public string maphong = "";
29 static public string mato = "";
30 public frmchonbcluong()
31 {
32 InitializeComponent();
33 for (int i = 1; i <= 12; i++)
34 {
35 cbothangbh.Items.Add(i);
36 }
37 for (int i = 2008; i <= 2100; i++)
38 {
39 cbonambh.Items.Add(i);
40 }
41 for (int i = 1; i <= 12; i++)
42 {
43 cbothangbc.Items.Add(i);
44 }
45 for (int i = 2008; i <= 2100; i++)
46 {
47 cbonambc.Items.Add(i);
48 }
49 cbophong.DataSource = cphong.taocombo();
50 cbophong.DisplayMember = "tbl_phongban.tenphong";
51 cbophong.ValueMember = "tbl_phongban.maphong";
52
53 }
54 //kiểm tra bảng lương có tồn tại hay không
55 private bool kiemtra(string thang, string nam)
56 {
57 ds.Clear();
58 string sel = "select * from tbl_BangLuong where thang ='" + thang
59 + "' and nam ='" + nam + "'";
60 sc.Open();
61 SqlCommand scmd = new SqlCommand(sel, sc);
62 object o = scmd.ExecuteScalar();
63 sc.Close();
64 if (o != null)
65 return true;
66 else
67 return false;
68 }
69
70 static public DataSet bcbaohiem(string thang, string nam)
71 {
72 SqlConnection sc = frmMain.me.sql.connectSQL();
73 SqlDataAdapter sda = new SqlDataAdapter();
74 DataSet ds = new DataSet();
75 ds.Clear();
76 sc.Open();
77 string sel = "select * from tbl_BangLuong where thang ='" + thang
78 + "' and nam ='" + nam + "'";
79 SqlCommand scmd = new SqlCommand(sel, sc);
80 sda.SelectCommand = scmd;
81 sda.Fill(ds, "baohiem");
82 string sel1 = "select * from tbl_nhanvien";
83 SqlCommand scmd1 = new SqlCommand(sel1, sc);
84 sda.SelectCommand = scmd1;
85 sda.Fill(ds, "nhanvien");
86 sc.Close();
87 ds.WriteXmlSchema("bcbaohiem.xml");
88 return ds;
89 }
90 private void cbophong_SelectedIndexChanged(object sender, EventArgs e)
91 {
92 cboto.DataSource = cto.taocombo(cbophong.SelectedValue.ToString());
93 cboto.DisplayMember = "DanhMucto.tento";
94 cboto.ValueMember = "DanhMucto.mato";
95 cboto.Text = "";
96 }
97
98 private void cmdin_Click(object sender, EventArgs e)
99 {
100 thangbc = ""; thangbh = ""; nambc = ""; nambh = ""; maphong = ""; mato = "";
101 if (kiemtra(cbothangbc.Text.Trim(), cbonambc.Text.Trim()) == true)
102 {
103 thangbc = cbothangbc.Text.Trim();
104 nambc = cbonambc.Text.Trim();
105 if (cboto.Text.Trim() == "")
106 {
107 maphong = cbophong.SelectedValue.ToString();
108 frmrptluongtheophong f = new frmrptluongtheophong();
109 f.MdiParent = this.MdiParent;
110 f.Show();
111 }
112 else
113 {
114 mato = cboto.SelectedValue.ToString();
115 maphong = cbophong.SelectedValue.ToString();
116 frmrptluongtheophong f = new frmrptluongtheophong();
117 f.MdiParent = this.MdiParent;
118 f.Show();
119 }
120 }
121 else
122 {
123 RadMessageBox.Show("\nKhông có dữ liệu bảng lương này !\n", "Thông báo",MessageBoxButtons.OK,RadMessageIcon.Error);
124 }
125 }
126
127 private void frmchonbcluong_Load(object sender, EventArgs e)
128 {
129 thangbc = ""; thangbh = ""; nambc = ""; nambh = ""; maphong = ""; mato = "";
130 }
131
132 private void cmdinbh_Click(object sender, EventArgs e)
133 {
134 if (kiemtra(cbothangbh.Text.Trim(), cbonambh.Text.Trim()) == true)
135 {
136 thangbh = cbothangbh.Text.Trim();
137 nambh = cbonambh.Text.Trim();
138 frmrptbcbh f = new frmrptbcbh();
139 f.MdiParent = this.MdiParent;
140 f.Show();
141 }
142 else
143 {
144 RadMessageBox.Show("\nBạn chưa có bảng lương tháng này ! \n Nên không có bảng báo cáo !\n", "Thông báo",MessageBoxButtons.OK,RadMessageIcon.Error);
145 }
146 }
147
148
149 }
150 }
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using Telerik.Data;
13 using QuanLyNhanSu.Class;
14 namespace QuanLyNhanSu
15 {
16 public partial class frmchonbcluong : RadForm
17 {
18 //khai báo biến toàn cục
19 public SqlConnection sc = frmMain.me.sql.connectSQL();
20 public SqlDataAdapter sda = new SqlDataAdapter();
21 public DataSet ds = new DataSet();
22 clsdmpb cphong = new clsdmpb();
23 clsDMTo cto = new clsDMTo();
24 static public string thangbc = "";
25 static public string nambc = "";
26 static public string thangbh = "";
27 static public string nambh = "";
28 static public string maphong = "";
29 static public string mato = "";
30 public frmchonbcluong()
31 {
32 InitializeComponent();
33 for (int i = 1; i <= 12; i++)
34 {
35 cbothangbh.Items.Add(i);
36 }
37 for (int i = 2008; i <= 2100; i++)
38 {
39 cbonambh.Items.Add(i);
40 }
41 for (int i = 1; i <= 12; i++)
42 {
43 cbothangbc.Items.Add(i);
44 }
45 for (int i = 2008; i <= 2100; i++)
46 {
47 cbonambc.Items.Add(i);
48 }
49 cbophong.DataSource = cphong.taocombo();
50 cbophong.DisplayMember = "tbl_phongban.tenphong";
51 cbophong.ValueMember = "tbl_phongban.maphong";
52
53 }
54 //kiểm tra bảng lương có tồn tại hay không
55 private bool kiemtra(string thang, string nam)
56 {
57 ds.Clear();
58 string sel = "select * from tbl_BangLuong where thang ='" + thang
59 + "' and nam ='" + nam + "'";
60 sc.Open();
61 SqlCommand scmd = new SqlCommand(sel, sc);
62 object o = scmd.ExecuteScalar();
63 sc.Close();
64 if (o != null)
65 return true;
66 else
67 return false;
68 }
69
70 static public DataSet bcbaohiem(string thang, string nam)
71 {
72 SqlConnection sc = frmMain.me.sql.connectSQL();
73 SqlDataAdapter sda = new SqlDataAdapter();
74 DataSet ds = new DataSet();
75 ds.Clear();
76 sc.Open();
77 string sel = "select * from tbl_BangLuong where thang ='" + thang
78 + "' and nam ='" + nam + "'";
79 SqlCommand scmd = new SqlCommand(sel, sc);
80 sda.SelectCommand = scmd;
81 sda.Fill(ds, "baohiem");
82 string sel1 = "select * from tbl_nhanvien";
83 SqlCommand scmd1 = new SqlCommand(sel1, sc);
84 sda.SelectCommand = scmd1;
85 sda.Fill(ds, "nhanvien");
86 sc.Close();
87 ds.WriteXmlSchema("bcbaohiem.xml");
88 return ds;
89 }
90 private void cbophong_SelectedIndexChanged(object sender, EventArgs e)
91 {
92 cboto.DataSource = cto.taocombo(cbophong.SelectedValue.ToString());
93 cboto.DisplayMember = "DanhMucto.tento";
94 cboto.ValueMember = "DanhMucto.mato";
95 cboto.Text = "";
96 }
97
98 private void cmdin_Click(object sender, EventArgs e)
99 {
100 thangbc = ""; thangbh = ""; nambc = ""; nambh = ""; maphong = ""; mato = "";
101 if (kiemtra(cbothangbc.Text.Trim(), cbonambc.Text.Trim()) == true)
102 {
103 thangbc = cbothangbc.Text.Trim();
104 nambc = cbonambc.Text.Trim();
105 if (cboto.Text.Trim() == "")
106 {
107 maphong = cbophong.SelectedValue.ToString();
108 frmrptluongtheophong f = new frmrptluongtheophong();
109 f.MdiParent = this.MdiParent;
110 f.Show();
111 }
112 else
113 {
114 mato = cboto.SelectedValue.ToString();
115 maphong = cbophong.SelectedValue.ToString();
116 frmrptluongtheophong f = new frmrptluongtheophong();
117 f.MdiParent = this.MdiParent;
118 f.Show();
119 }
120 }
121 else
122 {
123 RadMessageBox.Show("\nKhông có dữ liệu bảng lương này !\n", "Thông báo",MessageBoxButtons.OK,RadMessageIcon.Error);
124 }
125 }
126
127 private void frmchonbcluong_Load(object sender, EventArgs e)
128 {
129 thangbc = ""; thangbh = ""; nambc = ""; nambh = ""; maphong = ""; mato = "";
130 }
131
132 private void cmdinbh_Click(object sender, EventArgs e)
133 {
134 if (kiemtra(cbothangbh.Text.Trim(), cbonambh.Text.Trim()) == true)
135 {
136 thangbh = cbothangbh.Text.Trim();
137 nambh = cbonambh.Text.Trim();
138 frmrptbcbh f = new frmrptbcbh();
139 f.MdiParent = this.MdiParent;
140 f.Show();
141 }
142 else
143 {
144 RadMessageBox.Show("\nBạn chưa có bảng lương tháng này ! \n Nên không có bảng báo cáo !\n", "Thông báo",MessageBoxButtons.OK,RadMessageIcon.Error);
145 }
146 }
147
148
149 }
150 }